Certification
Digital Learning
Solve the challenge, share your solution and summit the ranks of our Community!
Also available in |
Français |
Português |
Español |
日本語
Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
Featured
Activity Feed
Hi Community members,
A solution to last week’s challenge can be found here.
This challenge was submitted by [First and Last Name], [@Community User Name]. Thank you, [First Name] for your submission!
In this week’s challenge,...
1
30
Hello Community members,
A solution to last week’s challenge can be found here.
This week’s challenge was submitted by Talia Sanders (@tsand22) . Thank you, Talia, for this incredible challenge!
Every year, parents and guardia...
Labels:
- Labels:
-
Core
-
Data Preparation
-
Intermediate
-
Parse
-
Transform
4
114
Hello Community Members!
A solution to last week’s challenge can be found here.
It's time to put your spatial skills to the test again! This challenge, submitted by Claire McCollough (@clmc9601), will challenge you to use the Desig...
Labels:
- Labels:
-
Advanced
-
Intermediate
-
Spatial Analysis
10
102
Hi Maveryx,
A solution to last week’s challenge can be found here.
This challenge was submitted by our ACE and an active member in the Alteryx Community, Ippei Nakagawa (@gawa) . Thank you Gawa for your contribution and we look...
Labels:
9
87
Hi Maveryx,
A solution to last week’s challenge can be found here.
Roland (@RWvanLeeuwen) submitted this challenge as a follow-on to our Valentine’s Day spatial challenge, and solving it now is a great way to celebrate summer in...
Labels:
- Labels:
-
Advanced
-
Intermediate
-
Spatial Analysis
5
67
Hi Community,
We posted the solution JSON file to Cloud Quest #34. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!
Let’s dive into this week's quest!
Download t...
Labels:
1
3
Hello Community members,
A solution to last week’s challenge can be found here.
This week’s challenge was submitted by Patrick Digan (@patrick_digan) . Thank you, Patrick, for submitting this great challenge!
In this challenge...
Labels:
- Labels:
-
Advanced
-
Basic
-
Data Preparation
9
142
Hi Community Members,
A solution to last week’s challenge can be found here.
This challenge was submitted by Ashley Talai (@aatalai). Thank you, Ashley, for this week’s challenge, as we celebrate Pi Day!
Every year in the Unit...
Labels:
- Labels:
-
Core
-
Data Preparation
-
Intermediate
-
Join
4
67
Hi Community members,
A solution to last week’s challenge can be found here.
This week's challenge was inspired by a submission from Vikas Gupta. We appreciate Vikas' contribution! It is great to include the versatile RegEx tool...
Labels:
- Labels:
-
Advanced
-
Data Parsing
-
Intermediate
4
60
Activity Feed
Hi Community members,
A solution to last week’s challenge can be found here.
This challenge was submitted by [First and Last Name], [@Community User Name]. Thank you, [First Name] for your submission!
In this week’s challenge, you apply your skills with formulas, macros, and analytic apps to simulate a basic probability experiment: flipping a coin. This challenge helps you practice building iterative logic and user-driven apps in Alteryx Designer.
Here are the steps you need to follow to build the flip-coin app:
Create an Iterative Macro (`Coin Flip Macro.yxmc`) that repeats the coin flip simulation for a specified number of times. This macro should:
Initialize with a Text Input containing iterations, head count and tail count.
Update the counts on each iteration.
Use a condition to stop once the iteration count reaches the user-specified total.
Once the macro is created, build the analytic app that does the following:
Prompts the user with a Text Box question: "How Many Coin Flips?"
Passes this input into the macro to determine the number of simulations it runs.
Displays how many times "Heads" and "Tails" occurred.
Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.
Good Luck!
The Academy Team
Download Start File
... View more
1
30
Hello Community members,
A solution to last week’s challenge can be found here.
This week’s challenge was submitted by Talia Sanders (@tsand22) . Thank you, Talia, for this incredible challenge!
Every year, parents and guardians need to purchase school supplies for their children at the beginning of the school year. This is a major cost that many families struggle to budget for.
In Part 1 of this challenge, your objective is to calculate the cost of school supplies for one child in each grade of elementary school (from kindergarten to sixth grade).
There are two datasets provided:
School Supply List Text Input: A list of school supplies separated by grade.
Cost of School Supplies Text Input: The cost of each unit from a list of school supplies.
Need a refresher? Review the following lessons in Academy to gear up:
Changing Data Layouts
Sorting Data
Ready? Good luck!
The Academy Team
Download Start File
Download Solution File
Data Source:
https://www.in.gov/doe/it/data-center-and-reports/
... View more
Labels:
4
114
Hello Community Members!
A solution to last week’s challenge can be found here.
It's time to put your spatial skills to the test again! This challenge, submitted by Claire McCollough (@clmc9601), will challenge you to use the Designer Spatial palette efficiently.
You are provided with two datasets. The first dataset contains polygons representing the counties of Maine, a state in the USA. The second dataset contains a polygon representing the Gulf of Maine, located in the nearby waters of the Atlantic Ocean.
Your tasks are to:
Identify which Maine county has the longest coastline on the Gulf of Maine. (Exclude any islands smaller than 5 kilometers.)
Determine which county has the most small islands. (An island is considered small if it is less than 5 square kilometers.)
Need a refresher? Review the Spatial Analytics lessons in Academy to gear up.
Happy solving!
The Academy Team
... View more
Labels:
10
102
Hi Maveryx,
A solution to last week’s challenge can be found here.
This challenge was submitted by our ACE and an active member in the Alteryx Community, Ippei Nakagawa (@gawa) . Thank you Gawa for your contribution and we look forward to the next ones that you may bring to the table!
Across the United States, an annular solar eclipse was observed on October 14, 2023, and a total solar eclipse will be observed on April 8, 2024. In this challenge, you will determine which lucky cities in the USA observed an annular solar eclipse in 2023 and which ones will observe the total solar eclipse in 2024, as well as one lucky city that will observe both! The provided datasets include solar eclipse information from 2023 and 2024 including the name of the city; latitude and longitude of the city; how long the eclipse will last; and the eclipse’s category (P: partial, T: total, A: annual).
Your tasks:
Create a combined list of the cities that observed the annular eclipse in 2023 and which cities will observe the total eclipse in 2024.
Create a map to visualize each eclipse’s path throughout the year for 2023 and 2024.
Determine the lucky city that will get to see both eclipses!
Hint: The provided datasets are JSON files. To facilitate the data extraction, use the Parse JSON tool in the Developer tab of Designer.
Need a refresher? Review these lessons in Academy to gear up:
Changing Data Layouts
Parsing JSON
Creating Spatial Objects
Sources: https://svs.gsfc.nasa.gov/ https://svs.gsfc.nasa.gov/vis/a000000/a005000/a005073/2023_city_times.json
https://svs.gsfc.nasa.gov/vis/a000000/a005000/a005073/2024_city_times.json
Good luck!
... View more
Labels:
9
87
Hi Maveryx,
A solution to last week’s challenge can be found here.
Roland (@RWvanLeeuwen) submitted this challenge as a follow-on to our Valentine’s Day spatial challenge, and solving it now is a great way to celebrate summer in the northern hemisphere. Thank you, Roland, for submitting another great challenge!
In Challenge #413 you applied your data analytics skills to help your friends visit as many ice cream shops as possible, including those that served a particular ice cream flavor. However, your friends are now worried about all the caloric intake, and for the next road trip they want to add some balance by focusing on store locations that are somewhat clustered together so you can all ride your bicycles to the ice cream shops instead!
Note: This challenge helps us check whether a group of shops might be located on the border of multiple states. We need to eliminate the limitation that the closest stores have to be located in the same state. Additionally, the bike ride you and your friends plan to take has specific distance parameters that you all believe will work best.
Your tasks for this challenge:
Create grids with cells that are 1 mile in size, and for each grid, find the 100 nearest ice cream shops within a 40-mile radius.
Select the grid cells that have at least 10 ice cream shops.
Select the 100 grid cells with the lowest average distance between the shops and the grid cell location.
Need a refresher? Review the following lessons in Academy to gear up:
Spatial Analytics
Summarizing Data
Good luck!
... View more
Labels:
5
67